Using the Advanced Filter Wizard

Axiom Software allows you to use or create your own filters to customize the data to include in some utilities and reports. The Advanced Filter Wizard walks you through the process of building complex limit query filters rather than having to construct them manually. You can create and save new filters for future use as well as use and edit existing filters.

Use an existing filter

To use an existing filter:

  1. Next to the Preview field, click the folder icon.

    Click image to view full size

  2. In the Filter Library dialog, select the filter to use, and click OK.

    TIP: You can edit an existing filter by selecting a filter and following the steps in Creating a filter below.

  3. In the Filter Wizard dialog, click Apply.
  4. Click OK.

Creating a filter

To create a filter:

  1. In the left side of the dialog, select the table column on which you want to base the filter. After you select a table column, the values in that column display in the right side of the dialog.

    Click image to view full size

  2. In the right side of the dialog, type or select the value on which to base the filter. You can type into the field above the list of values to filter the list or to specify a value. If one or more values are selected, then those items are used in the filter. Otherwise, whatever you type into the field is used by the filter.

  3. In the space between the two selection boxes, select the operator to use for the filter criteria statement, such as equals, not equals, greater than, or less than.

    Click image to view full size

  4. Review the filter criteria statement in the Preview box to ensure that it is as intended. If you need to make changes, edit your selections made above.

    Click image to view full size

  5. Do one of the following:
    • If the filter criteria statement is finished, click OK. The Filter Wizard uses the statement in the Preview box (you do not have to click Apply in this case).
    • To create a compound filter, click Apply to move the current criteria statement into the Filter box. Then, repeat Steps a-d to create another criteria statement. When the next statement is complete, click AND or OR to join it to the prior statement.

  6. To save the filter, click the disk icon next to the Apply box.

    Click image to view full size

  7. In the File name field, type a name for the filter.
  8. In the Description field, type a description of what the filter does.
  9. Click Save.
  10. In the Filter Wizard dialog, click OK.